CREATE SCHEMA `sldb` DEFAULT CHARACTER SET gb2312;
USE `sldb`;

CREATE TABLE `useraccount` (
  `Account` varchar(20) NOT NULL default '',
  `Password` varchar(20) NOT NULL default '',
  `Char1` varchar(24) default '',
  `Char2` varchar(24) default '',
  `Char3` varchar(24) default '',
  `Char4` varchar(24) default '',
  `Char5` varchar(24) default '',
  `Permission` int(4) NOT NULL default '0',
  `LastConnectDate` varchar(24) default '2004-01-01',
  `LastConnectTime` varchar(24) default '11:11:11',
  PRIMARY KEY  (`Account`)
);

INSERT INTO `useraccount` (`Account`, `Password`, `Permission`) VALUES ('shininglore', '12345', 0);
INSERT INTO `useraccount` (`Account`, `Password`, `Permission`) VALUES ('celes', '12345', 50);

CREATE USER 'celes'@'localhost' IDENTIFIED BY '12345';
GRANT ALL PRIVILEGES ON `sldb`.* TO 'celes'@'localhost';
